4D Analytics

Attributes (Properties) Toolbar

  • All the Attributes calculations work of the Attribute Archive and this should be populated for the point(s) being used.
  • Calculation will use the appropriate Attribute Archive value for the timestamp being created by the calculator.
  • It is sensible that for every Standard Data timestamp record belonging to the point there is a corresponding Attribute Archive record for the timestamp also but this is not required.

PropTime

  • For example, PropTimeDiff[{P1628903}; LAST_SERVICE; d]
  • First parameter is the point ident, second parameter is the Attribute name, third parameter represents the time units to be used and should be changed by the user if necessary.
  • Options for time units are represented by: yyyy (years), m (months), d (days), h (hours), n (minutes), s (seconds).
  • The Attribute Archive values should be in one of the following formats: yyyy-mm-dd, yyyy-mm-dd hh:mm, yyyy-mm-dd hh:mm:ss.
  • Returns an integer representing the time difference between the Attribute value and the calculation time.

PropNumeric

  • For example, PropVal[{P1628903}; SCALE_FACTOR].
  • First parameter is the point ident, second parameter is the Attribute name.
  • Returns the numeric value of the appropriate Attribute Archive value record.
  • The returned numeric value can be used directly as part of a calculation or within the ‘If’ statement of a conditional calculation.

PropText

  • For example, PropText[{P1628903}; METER_SERIAL; RZ321].
  • First parameter is the point ident, second parameter is the Attribute name, third parameter is the text the Attribute Archive value will be compared to.
  • The third parameter can contain ‘%’ for wildcard matching e.g. 123%, RZ3%, etc.
  • Returns a 1 when the appropriate Attribute Archive value matches the third parameter, otherwise it returns 0.